About Using Databases

Databases are integral part of almost all IVR applications. Recognizing this fact, VBVoice is equipped with a set of three high level controls, designed specifically for accessing databases:

  1. DataFind

  1. DataChange

  1. DataSwitch

You can find more information on these controls in the Toolbox Reference.

Sometimes the VBVoice data controls may not be enough for your application. Because VBVoice is fully integrated with Visual Basic, there are hundreds of alternative database access tools available from both Microsoft and other parties which may be easily integrated into your project.

However, remember that your telephony application will be dealing with many concurrent calls, so you must consider issues of multi-threading and synchronization. Some third party components may not be designed for a multi-threading environment.

Review the threading model applicable to your database before deciding on your architecture. If needed, review some general database concepts before learning how to create and access databases in VBVoice.

Creating a Database

Visual Basic's Data Manager tool creates, views, and updates simple Access format databases. Data Manager can be started from the VB Add-Ins menu.

Accessing the Data

In VBVoice, access databases by using four controls:

  1. Visual Basic's Data Control

Opens the database and identifies data properties. Use of this control is optional.

  1. DataFind

Searches for a database record based on matching criteria.

  1. DataSwitch

Reads a database record and routes according to the value obtained.

  1. VBVoice's DataChange Controls

Changes data in a database record.

A full discussion of the VBVoice controls and their properties is presented in the Toolbox Reference.

Viewing Sample Database Applications

Refer to the example applications in the VBVoice Install Directory.

DialDB, DialODBC

Demonstrate how to dial out using a database.

Inventory

Demonstrates how to provide access to an inventory of parts stored in a database.

RecordDB

Demonstrates how to create and update information in a database.

Read about:

Reviewing Recordsets